BEGIN TRANSACTION
GO
ALTER TABLE dbo.data_SalesInfo ADD
	RTAmount numeric(13, 2) NOT NULL CONSTRAINT DF_data_SalesInfo_RTAmount DEFAULT ((0)),
	DiscAmount numeric(13, 2) NOT NULL CONSTRAINT DF_data_SalesInfo_DiscAmount DEFAULT ((0)),
	GSTAmount numeric(13, 2) NOT NULL CONSTRAINT DF_data_SalesInfo_GSTAmount DEFAULT ((0))
GO
COMMIT

------------------------------------------

BEGIN TRANSACTION
GO
	UPDATE  data_SalesInfo SET RTAmount = (SELECT  SUM(RTAmount) AS Amount FROM  data_SalesDetail WHERE (SalesID = data_SalesInfo.SalesID))
	UPDATE  data_SalesInfo SET DiscAmount = (SELECT  SUM(DiscAmount) AS Amount FROM  data_SalesDetail WHERE (SalesID = data_SalesInfo.SalesID))
	UPDATE  data_SalesInfo SET GSTAmount = (SELECT  SUM(GSTAmount) AS Amount FROM  data_SalesDetail WHERE (SalesID = data_SalesInfo.SalesID))        
GO
COMMIT